package net.mikoo.seals.manage.web.common.helper;

import java.io.IOException;
import java.io.InputStream;
import java.util.Date;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

import com.google.gson.JsonObject;

import net.mikoo.seals.common.enums.PartyStatusEnum;
import net.mikoo.seals.model.Party;
import net.mikoo.seals.model.Person;
import net.mikoo.seals.model.UserLogin;

public class ExcelHelper {
	
	
	public  void aa(InputStream in) {
		
		try {
			
			
			
			Workbook wb0 = new HSSFWorkbook(in);
			Sheet sht0 = wb0.getSheetAt(0);
			
			
			for (Row r : sht0) {
				if (r.getRowNum() < 1) {
					continue;
				}

				String name = r.getCell(0).getStringCellValue();
				String gender = r.getCell(1).getStringCellValue();
				String position = r.getCell(2).getStringCellValue();
				
				Cell cell = r.getCell(3);
				cell.setCellType(CellType.STRING);
				String mobile = cell.getStringCellValue();
				String password = r.getCell(4).getStringCellValue();
				String email = r.getCell(5).getStringCellValue();
				
				
				
			}
			
			wb0.close();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}

}
